home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Developer Source 10
/
developer source - volume 10.iso
/
oracl
/
mar97
/
koopf105.gif
< prev
next >
Graphics Interchange Format
|
1998-02-10
|
16KB
|
633x189
|
4-bit (15 colors)
Labels:
text
|
font
|
number
|
screenshot
|
black and white
OCR:
FIGURE 5: The nonunique test. Clustering for the nonunique index drops significantly, whereas clustering for the primary key rises. blkixchk.sql Alloc Avg. Leaf Blocks Avg. Data Blocks Distinct Number Pct. Cluster Index Uniqueness Blocks Level Blocks por Key por Key Køys of Rows Clustering for Rows Estimate Statistics: JKOOPM1.TESTI_PK UNIQUE 775 JKOOPMI.TESTI_PL_AUDT_DT 2 2 736 1 402 1 78,656 NONUNIQUE 5 5 79,167 68 79,167 77,964 98.48 1,496 1.89 Compute Statistics: JKOOPM1.TEST1_PK JKOOPM1.TEST1_PL_AUDT_DT UNIQUE 775 1 1 79,112 79,112 78,398 99.10 NONUNIQUE 415 2 734 2 399 12 68 79,112 1,186 1.50 blkixsts.sql Usable Usable Deleted Corist Space in Branch Space in Deleted Leaf Mast Rows Gel B-Tree Used Leaf Branch Branch Leaf Rows Repeat per Space Space Pct. Nome Blocks Blod Rows Blocks Block Rows Length Key Key Access Used ... .. .. .. ..... JKOOPM1.TEST1_PL_AUDT_DT 410 3924 409 JKOOPM1.TEST1_PK 5 5 3956 1147 577 1590 1476 93.00 734 733 39.56 1164 3924 0 4 2832 6561 70.00